DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50023} closed
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10005, pstmt-20012} clearParameters. 
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20014} created. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20013} created. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20015} created. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20014} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20015} Parameters : []
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20013} Parameters : []
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20015} Types : []
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20014} Types : [VARCHAR]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20013} Types : []
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20015} executed. 1.5696 millis. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20014} executed. 2.2108 millis. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20014, rs-50025} open
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Header: [competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20014, rs-50025} Header: [date, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Result: [35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20014, rs-50025} Result: [1718585969554, 辩论大赛, 知识竞赛, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 1, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Result: [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 5]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20014, rs-50025} Result: [1703122462137, 计算机组装大赛, 科技竞赛, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20013} executed. 3.4855 millis. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Result: [6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 3]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20014, rs-50025} Result: [1718641167555, test, 学科竞赛, f46a9634-77b6-43b0-8728-545bc84f0a95, 1, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Header: [user_id, user_name, email, password, name, phone, sex, user_className, period, role_id, role_name, college_id, college_name, university_id, university_name]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Result: [b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 3]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20014, rs-50025} closed
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Result: [b7a13312-c532-4d01-9c16-2caa89491640, 人工智能大赛, 2]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20014} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} Result: [f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 3]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [10, 20160216010, 19999999999@qq.com, 142d2175786b0a3e694d5230b8faebce, 赵一, 19999999999, 男, 计科3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50024} closed
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [12, 20160216100, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20015} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20016} created. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20016} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [15, 20160216105, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20016} Types : [VARCHAR]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [16, 20160216106, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [17, 20160216107, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [18, 20160216108, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [19, 20160216109, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20016} executed. 15.7362 millis. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20016, rs-50027} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [20, 20160216110, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20016, rs-50027} Header: [captain_id, apply_time, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [21, 20160216111, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20016, rs-50027} closed
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [21760cab-011c-435f-85cb-520adf25f7a9, 1, 123456789, 6932058980060f2c9130b59fd53b063b, 小狗, 123456789, 女, 软工四班, 2022, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20016} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [22, 20160216122, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [23, 20160216123, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [24, 20160216124, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [25, 20160216125, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [26, 20160216126, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [27, 20160216127, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [3, 20160216003, 12222222222@qq.com, bb3ff4cb46696769ac6d5585cf676dc9, 李四, 12222222222, 男, 计科（高博）3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [4, 20160216004, 13333333333@qq.com, 0bf9692378bc43a627c8f06d8cf0dc3f, 王五, 13333333333, 女, 计科2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [5, 20160216005, 14444444444@qq.com, 462ae56b5f766c9063d9485bab8af2e1, 赵六, 14444444444, 女, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [6, 20160216006, 15555555555@qq.com, 31a56597d1cfa721c47f06b7aba8537b, 田七, 15555555555, 女, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [62714ebe-84b2-4280-987a-51dd805b4206, 12335564, null, 6203b523658908e9f2e8eae8227b1436, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [7, 20160216007, 16666666666@qq.com, 56c107fa559c745087bc7761825117cb, 王八, 16666666666, 女, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [8, 20160216008, 17777777777@qq.com, 43fcbe0f248a5d053bd3d2e25ceed982, 张四, 17777777777, 女, 计科（高博）2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [8c748c34-68ba-4ab6-bb4a-052111a4dd96, 2140707168, null, d5d470762c8fc9f3024d35574693ab5f, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [9, 20160216009, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, 陈六, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [9164b69d-b49e-468a-8f0c-bddfdfe896bf, 123456789123, null, 825ea423e9c0ad5cca03a6030b872e8e, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [9f14560c-4d1a-493f-8bd6-4d732d139db3, 2140707167, null, 2ffb196ba326771b64e836a249c18639, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [a098f98d-8eec-4885-9669-417bc0fbeff2, 2148, null, 8229bd86aab0b24e35c84da82e5c8ca4, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} Result: [d90b5e01-c706-442a-b1f5-8b2dff08a2ec, 2140129259, null, ccc4a79790646ca4e93898d6d05e8207, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50026} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20013} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20017} created. SELECT n.notification_id notification_id,n.notification_time notification_time,n.notification_title
        notification_title,
        c.competition_id competition_id, c.competition_name competition_name,f.file_path file_path, f.file_name
        file_name,
        f.file_id file_id
        -- , c.competition_level competition_level,
        -- c.competition_type competition_type, c.competition_site competition_site,
        -- c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        LEFT JOIN t_file f
        ON f.notification_id = n.notification_id
        WHERE n.notification_type = ?
        ORDER BY notification_time DESC
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20017} Parameters : [2]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20017} Types : [INTEGER]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20017} executed. 2.5405 millis. SELECT n.notification_id notification_id,n.notification_time notification_time,n.notification_title
        notification_title,
        c.competition_id competition_id, c.competition_name competition_name,f.file_path file_path, f.file_name
        file_name,
        f.file_id file_id
        -- , c.competition_level competition_level,
        -- c.competition_type competition_type, c.competition_site competition_site,
        -- c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        LEFT JOIN t_file f
        ON f.notification_id = n.notification_id
        WHERE n.notification_type = ?
        ORDER BY notification_time DESC
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} open
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} Header: [notification_id, notification_time, notification_title, competition_id, competition_name, file_path, file_name, file_id]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} Result: [d9c63c0d-e330-40d0-bd36-b0e8b5ff8206, 1701252324521, 辩论大赛获奖通知, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 辩论大赛, C:\Users\Administrator\Desktop\file\notification\d9c63c0d-e330-40d0-bd36-b0e8b5ff8206\辩论大赛获奖名单.xlsx, 辩论大赛获奖名单.xlsx, b605c9be-300c-4e63-8f44-815f7984bbb8]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} Result: [b6298017-2768-4bbb-95f3-f6118a7c726a, 1701152324521, 生活大赛获奖名单, 42b487e4-062b-4ca2-8585-925549b5ce87, 生活知识竞赛, null, null, null]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} Result: [447b040c-7a05-4e41-be46-022ea5b83377, 1701112312456, 兵乓球大赛获奖名单, ffe2ef61-69c1-4627-87eb-510948608f0d, 兵乓球大赛, null, null, null]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} Result: [ecab1296-ae54-4d64-8703-a8a03065cea7, 1683896041724, 计算机组装大赛获奖名单, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 计算机组装大赛, C:\Users\Administrator\Desktop\file\notification\ecab1296-ae54-4d64-8703-a8a03065cea7\新建 Microsoft Word 文档.docx, 新建 Microsoft Word 文档.docx, 680cca23-ad42-4416-9aa1-6021b2b1eed5]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20017, rs-50028} closed
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20017} clearParameters. 
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20018} created. SELECT t.team_id team_id, t.team_name team_name, t.team_headcount team_headcount, t.team_content team_content,
        c.competition_id competition_id, c.competition_name competition_name, u.user_id user_id, u.name name,
        u.phone phone, u.email email
        FROM t_team t
        LEFT JOIN t_competition c
        ON c.competition_id = t.competition_id
        LEFT JOIN t_user u
        ON u.user_id = t.captain_id
        WHERE t.team_state = ? AND t.captain_id != ?
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20018} Parameters : [1, 5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20018} Types : [INTEGER, VARCHAR]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20018} executed. 2.2052 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_headcount team_headcount, t.team_content team_content,
        c.competition_id competition_id, c.competition_name competition_name, u.user_id user_id, u.name name,
        u.phone phone, u.email email
        FROM t_team t
        LEFT JOIN t_competition c
        ON c.competition_id = t.competition_id
        LEFT JOIN t_user u
        ON u.user_id = t.captain_id
        WHERE t.team_state = ? AND t.captain_id != ?
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Header: [team_id, team_name, team_headcount, team_content, competition_id, competition_name, user_id, name, phone, email]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [17527ebf-6d41-44ed-869e-bd5650c08efc, 田七英雄队, 2, 田七英雄队等待加入, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 6, 田七, 15555555555, 15555555555@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [1bfc9d8a-7485-4319-85ac-ec074f6366fd, test, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 3, 李四, 12222222222, 12222222222@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [2910159a-4ecb-4836-8c93-95907e325a6f, test, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 1, 黄宏展, 13592817348, 1624588099@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [2c19fdd2-a93d-457b-9b0b-764f234af7bc, 王五王者队, 1, 王五王者队, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [2d69c453-e7e4-444d-b806-57147cbc6e34, 口语赵六队, 1, 口语赵六队, b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [37731a17-b10f-41b4-8600-ad5acf5205df, 王五口语队, 1, 王五口语队, b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [72fd7591-87e5-411f-8b09-08bb34a26bac, 王五数模队, 1, 王五数模队招人, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [82ce95ce-a063-4835-9286-3c9cafea4270, 王者1队, 7, 等待广大玩家踊跃加入, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 2, 张三, 18888888888, 18888888888@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [99738531-a3c7-4378-9feb-7a676a4c69af, 数模赵六队, 2, 数模赵六队, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [9f71a5d0-e1d3-4027-b542-6b5c2c75eca2, 赵一英雄联盟队, 1, 赵一英雄联盟队, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 10, 赵一, 19999999999, 19999999999@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [a9659f7f-81a2-4239-b4e1-a668408f8cd2, 王者赵六队, 2, 王者赵六队, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [b4af2161-b5fe-4e33-b737-ed8761ea3c02, 张四联盟, 1, 张四联盟招人, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 8, 张四, 17777777777, 17777777777@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [b7996c26-bf12-409f-9347-d190f83f4c8d, 陈六联盟, 1, 陈六联盟, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 9, 陈六, 11111111111, 11111111111@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [c6202e86-0c86-4d8c-94b2-b837211badac, 赵六英语队, 1, 赵六英语队等待加入, f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} Result: [d57ea0cf-3079-4dbe-a8c5-3e41f9c4774f, 张四英语知识队, 1, 张四英语知识队, f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 8, 张四, 17777777777, 17777777777@qq.com]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20018, rs-50029} closed
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20018} clearParameters. 
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20019} created. SELECT * FROM t_user_team WHERE user_id = ?
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20019} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20019} Types : [VARCHAR]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20019} executed. 1.6293 millis. SELECT * FROM t_user_team WHERE user_id = ?
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20019, rs-50030} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20019, rs-50030} Header: [user_id, team_id]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20019, rs-50030} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2910159a-4ecb-4836-8c93-95907e325a6f]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20019, rs-50030} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 85a6312b-4ea0-449d-b5a0-71efc62d6584]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20019, rs-50030} closed
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20019} clearParameters. 
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} created. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20021} created. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20006} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} Parameters : []
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20021} Parameters : []
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20021} Types : []
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20006} Types : [VARCHAR]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} Types : []
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20021} executed. 1.3386 millis. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} open
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20006} executed. 2.0388 millis. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Header: [competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50032} open
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Result: [35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} executed. 4.2317 millis. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Result: [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 5]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50032} Header: [date, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Result: [6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 3]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} open
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Result: [b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 3]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50032} Result: [1718585969554, 辩论大赛, 知识竞赛, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 1, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Result: [b7a13312-c532-4d01-9c16-2caa89491640, 人工智能大赛, 2]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Header: [user_id, user_name, email, password, name, phone, sex, user_className, period, role_id, role_name, college_id, college_name, university_id, university_name]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} Result: [f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 3]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50032} Result: [1703122462137, 计算机组装大赛, 科技竞赛, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20021, rs-50031} closed
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20021} clearParameters. 
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50032} Result: [1718641167555, test, 学科竞赛, f46a9634-77b6-43b0-8728-545bc84f0a95, 1, 1]
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50032} closed
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [10, 20160216010, 19999999999@qq.com, 142d2175786b0a3e694d5230b8faebce, 赵一, 19999999999, 男, 计科3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20006} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [12, 20160216100, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20007} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20007} Types : [VARCHAR]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [15, 20160216105, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [16, 20160216106, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [17, 20160216107, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20007} executed. 2.0933 millis. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [18, 20160216108, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20007, rs-50034} open
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [19, 20160216109, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20007, rs-50034} Header: [captain_id, apply_time, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20007, rs-50034} closed
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [20, 20160216110, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20007} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [21, 20160216111, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [21760cab-011c-435f-85cb-520adf25f7a9, 1, 123456789, 6932058980060f2c9130b59fd53b063b, 小狗, 123456789, 女, 软工四班, 2022, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [22, 20160216122, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [23, 20160216123, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [24, 20160216124, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [25, 20160216125, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [26, 20160216126, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [27, 20160216127, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [3, 20160216003, 12222222222@qq.com, bb3ff4cb46696769ac6d5585cf676dc9, 李四, 12222222222, 男, 计科（高博）3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [4, 20160216004, 13333333333@qq.com, 0bf9692378bc43a627c8f06d8cf0dc3f, 王五, 13333333333, 女, 计科2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [5, 20160216005, 14444444444@qq.com, 462ae56b5f766c9063d9485bab8af2e1, 赵六, 14444444444, 女, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [6, 20160216006, 15555555555@qq.com, 31a56597d1cfa721c47f06b7aba8537b, 田七, 15555555555, 女, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [62714ebe-84b2-4280-987a-51dd805b4206, 12335564, null, 6203b523658908e9f2e8eae8227b1436, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [7, 20160216007, 16666666666@qq.com, 56c107fa559c745087bc7761825117cb, 王八, 16666666666, 女, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [8, 20160216008, 17777777777@qq.com, 43fcbe0f248a5d053bd3d2e25ceed982, 张四, 17777777777, 女, 计科（高博）2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [8c748c34-68ba-4ab6-bb4a-052111a4dd96, 2140707168, null, d5d470762c8fc9f3024d35574693ab5f, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [9, 20160216009, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, 陈六, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [9164b69d-b49e-468a-8f0c-bddfdfe896bf, 123456789123, null, 825ea423e9c0ad5cca03a6030b872e8e, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [9f14560c-4d1a-493f-8bd6-4d732d139db3, 2140707167, null, 2ffb196ba326771b64e836a249c18639, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [a098f98d-8eec-4885-9669-417bc0fbeff2, 2148, null, 8229bd86aab0b24e35c84da82e5c8ca4, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} Result: [d90b5e01-c706-442a-b1f5-8b2dff08a2ec, 2140129259, null, ccc4a79790646ca4e93898d6d05e8207, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50033} closed
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20022} created. SELECT t.team_id team_id, t.team_name team_name, t.team_headcount team_headcount, t.team_content team_content,
        c.competition_id competition_id, c.competition_name competition_name, u.user_id user_id, u.name name,
        u.phone phone, u.email email
        FROM t_team t
        LEFT JOIN t_competition c
        ON c.competition_id = t.competition_id
        LEFT JOIN t_user u
        ON u.user_id = t.captain_id
        WHERE t.team_state = ? AND t.captain_id != ?
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20022} Parameters : [1, 5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20022} Types : [INTEGER, VARCHAR]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20022} executed. 1.8707 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_headcount team_headcount, t.team_content team_content,
        c.competition_id competition_id, c.competition_name competition_name, u.user_id user_id, u.name name,
        u.phone phone, u.email email
        FROM t_team t
        LEFT JOIN t_competition c
        ON c.competition_id = t.competition_id
        LEFT JOIN t_user u
        ON u.user_id = t.captain_id
        WHERE t.team_state = ? AND t.captain_id != ?
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Header: [team_id, team_name, team_headcount, team_content, competition_id, competition_name, user_id, name, phone, email]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [17527ebf-6d41-44ed-869e-bd5650c08efc, 田七英雄队, 2, 田七英雄队等待加入, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 6, 田七, 15555555555, 15555555555@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [1bfc9d8a-7485-4319-85ac-ec074f6366fd, test, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 3, 李四, 12222222222, 12222222222@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [2910159a-4ecb-4836-8c93-95907e325a6f, test, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 1, 黄宏展, 13592817348, 1624588099@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [2c19fdd2-a93d-457b-9b0b-764f234af7bc, 王五王者队, 1, 王五王者队, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [2d69c453-e7e4-444d-b806-57147cbc6e34, 口语赵六队, 1, 口语赵六队, b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [37731a17-b10f-41b4-8600-ad5acf5205df, 王五口语队, 1, 王五口语队, b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [72fd7591-87e5-411f-8b09-08bb34a26bac, 王五数模队, 1, 王五数模队招人, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [82ce95ce-a063-4835-9286-3c9cafea4270, 王者1队, 7, 等待广大玩家踊跃加入, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 2, 张三, 18888888888, 18888888888@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [99738531-a3c7-4378-9feb-7a676a4c69af, 数模赵六队, 2, 数模赵六队, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [9f71a5d0-e1d3-4027-b542-6b5c2c75eca2, 赵一英雄联盟队, 1, 赵一英雄联盟队, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 10, 赵一, 19999999999, 19999999999@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [a9659f7f-81a2-4239-b4e1-a668408f8cd2, 王者赵六队, 2, 王者赵六队, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [b4af2161-b5fe-4e33-b737-ed8761ea3c02, 张四联盟, 1, 张四联盟招人, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 8, 张四, 17777777777, 17777777777@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [b7996c26-bf12-409f-9347-d190f83f4c8d, 陈六联盟, 1, 陈六联盟, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 9, 陈六, 11111111111, 11111111111@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [c6202e86-0c86-4d8c-94b2-b837211badac, 赵六英语队, 1, 赵六英语队等待加入, f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} Result: [d57ea0cf-3079-4dbe-a8c5-3e41f9c4774f, 张四英语知识队, 1, 张四英语知识队, f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 8, 张四, 17777777777, 17777777777@qq.com]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50035} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20022} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20023} created. SELECT * FROM t_user_team WHERE user_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20023} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20023} Types : [VARCHAR]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20023} executed. 1.7099 millis. SELECT * FROM t_user_team WHERE user_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20023, rs-50036} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20023, rs-50036} Header: [user_id, team_id]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20023, rs-50036} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2910159a-4ecb-4836-8c93-95907e325a6f]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20023, rs-50036} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 85a6312b-4ea0-449d-b5a0-71efc62d6584]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20023, rs-50036} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20023} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20024} created. SELECT n.notification_id notification_id,n.notification_time notification_time,n.notification_title
        notification_title,
        c.competition_id competition_id, c.competition_name competition_name,f.file_path file_path, f.file_name
        file_name,
        f.file_id file_id
        -- , c.competition_level competition_level,
        -- c.competition_type competition_type, c.competition_site competition_site,
        -- c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        LEFT JOIN t_file f
        ON f.notification_id = n.notification_id
        WHERE n.notification_type = ?
        ORDER BY notification_time DESC
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20024} Parameters : [2]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20024} Types : [INTEGER]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20024} executed. 2.5932 millis. SELECT n.notification_id notification_id,n.notification_time notification_time,n.notification_title
        notification_title,
        c.competition_id competition_id, c.competition_name competition_name,f.file_path file_path, f.file_name
        file_name,
        f.file_id file_id
        -- , c.competition_level competition_level,
        -- c.competition_type competition_type, c.competition_site competition_site,
        -- c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        LEFT JOIN t_file f
        ON f.notification_id = n.notification_id
        WHERE n.notification_type = ?
        ORDER BY notification_time DESC
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} open
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} Header: [notification_id, notification_time, notification_title, competition_id, competition_name, file_path, file_name, file_id]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} Result: [d9c63c0d-e330-40d0-bd36-b0e8b5ff8206, 1701252324521, 辩论大赛获奖通知, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 辩论大赛, C:\Users\Administrator\Desktop\file\notification\d9c63c0d-e330-40d0-bd36-b0e8b5ff8206\辩论大赛获奖名单.xlsx, 辩论大赛获奖名单.xlsx, b605c9be-300c-4e63-8f44-815f7984bbb8]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} Result: [b6298017-2768-4bbb-95f3-f6118a7c726a, 1701152324521, 生活大赛获奖名单, 42b487e4-062b-4ca2-8585-925549b5ce87, 生活知识竞赛, null, null, null]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} Result: [447b040c-7a05-4e41-be46-022ea5b83377, 1701112312456, 兵乓球大赛获奖名单, ffe2ef61-69c1-4627-87eb-510948608f0d, 兵乓球大赛, null, null, null]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} Result: [ecab1296-ae54-4d64-8703-a8a03065cea7, 1683896041724, 计算机组装大赛获奖名单, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 计算机组装大赛, C:\Users\Administrator\Desktop\file\notification\ecab1296-ae54-4d64-8703-a8a03065cea7\新建 Microsoft Word 文档.docx, 新建 Microsoft Word 文档.docx, 680cca23-ad42-4416-9aa1-6021b2b1eed5]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20024, rs-50037} closed
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20024} clearParameters. 
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20025} created. SELECT n.notification_id notification_id, n.notification_title notification_title, n.notification_content
        notification_content,
        n.notification_time notification_time, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_notification n
        LEFT JOIN t_file f
        ON f.notification_id = n.notification_id
        WHERE notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20025} Parameters : [1]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20025} Types : [INTEGER]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20025} executed. 1.6179 millis. SELECT n.notification_id notification_id, n.notification_title notification_title, n.notification_content
        notification_content,
        n.notification_time notification_time, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_notification n
        LEFT JOIN t_file f
        ON f.notification_id = n.notification_id
        WHERE notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} Header: [notification_id, notification_title, notification_content, notification_time, file_id, file_name, file_path]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} Result: [1db06542-5b24-4028-8ab5-17ab639ba31c, 系统开放使用公告, 系统已开放使用，现在可使用新版本的系统，如遇问题请到->个人->投诉建议填写反馈信息，若为系统问题核实后将给予奖励。, 1683896041724, 388c16bd-129f-4203-bf58-668314816aad, 系统使用说明.docx, C:\Users\Administrator\Desktop\file\notification\cdb60d6e-2245-4c7f-ad83-cb0709981bf8\系统使用说明.docx]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} Result: [2630eb8e-043a-442f-963c-0d4fe0942770, 测试, 测试, 1683896041724, null, null, null]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} Result: [732cb93d-f07f-40cb-be23-265388499e7a, 系统更新说明, 系统界面已于2023-05-12 22:04:11完成调整，界面调整并不影响用户使用，现在可使用新版本的系统，如遇问题请到->个人->投诉建议填写反馈信息，若为系统问题核实后将给予奖励。, 1683896041724, 0d8b4943-7107-4a56-a038-fab418adbf3a, 系统优化详情.docx, C:\Users\Administrator\Desktop\file\notification\732cb93d-f07f-40cb-be23-265388499e7a\系统优化详情.docx]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} Result: [d038d139-bb1f-4caf-89ff-8c5a2763ca0a, 系统更新公告, 系统上线使用出现部分问题，已于 2020年04月19日21点57分59秒 完成维护，可正常使用！如遇问题请到->个人->投诉建议填写反馈信息，若为系统问题核实后将给予奖励。, 1683896041724, null, null, null]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} Result: [dc158ec2-d9d8-4107-9681-feb01ad25c3b, 组队功能开放, 系统的组队功能已经全面开放，现在已可以进行组队，创建，解散，加入，招募等功能。可前往 我的比赛·队伍 查看，具体操作请下载操作文件进行阅读和查看，如遇问题请到->个人->投诉建议填写反馈信息，若为系统问题核实后将给予奖励。, 1683896041724, 93d4a0ca-d869-4cf0-ad46-fd661393bf09, 组队功能使用说明.docx, C:\Users\Administrator\Desktop\file\notification\dc158ec2-d9d8-4107-9681-feb01ad25c3b\组队功能使用说明.docx]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20025, rs-50038} closed
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20025} clearParameters. 
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20026} created. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20026} Parameters : [0]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20026} Types : [INTEGER]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20026} executed. 3.7105 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50039} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10004, pstmt-20026} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20010} Parameters : []
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20010} Types : []
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20010} executed. 1.3959 millis. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} open
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Header: [competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Result: [35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Result: [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 5]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Result: [6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 3]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Result: [b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 3]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Result: [b7a13312-c532-4d01-9c16-2caa89491640, 人工智能大赛, 2]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} Result: [f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 3]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50040} closed
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20010} clearParameters. 
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20009} Parameters : []
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20009} Types : []
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} Types : [VARCHAR]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} executed. 2.1545 millis. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50041} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50041} Header: [date, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50041} Result: [1718585969554, 辩论大赛, 知识竞赛, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 1, 1]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50041} Result: [1703122462137, 计算机组装大赛, 科技竞赛, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50041} Result: [1718641167555, test, 学科竞赛, f46a9634-77b6-43b0-8728-545bc84f0a95, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20009} executed. 5.9066 millis. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50041} closed
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} open
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Header: [user_id, user_name, email, password, name, phone, sex, user_className, period, role_id, role_name, college_id, college_name, university_id, university_name]
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [10, 20160216010, 19999999999@qq.com, 142d2175786b0a3e694d5230b8faebce, 赵一, 19999999999, 男, 计科3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} Types : [VARCHAR]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [12, 20160216100, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} executed. 2.5837 millis. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50043} open
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [15, 20160216105, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50043} Header: [captain_id, apply_time, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [16, 20160216106, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50043} closed
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [17, 20160216107, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [18, 20160216108, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [19, 20160216109, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [20, 20160216110, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [21, 20160216111, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [21760cab-011c-435f-85cb-520adf25f7a9, 1, 123456789, 6932058980060f2c9130b59fd53b063b, 小狗, 123456789, 女, 软工四班, 2022, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [22, 20160216122, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [23, 20160216123, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [24, 20160216124, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [25, 20160216125, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [26, 20160216126, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [27, 20160216127, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [3, 20160216003, 12222222222@qq.com, bb3ff4cb46696769ac6d5585cf676dc9, 李四, 12222222222, 男, 计科（高博）3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [4, 20160216004, 13333333333@qq.com, 0bf9692378bc43a627c8f06d8cf0dc3f, 王五, 13333333333, 女, 计科2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [5, 20160216005, 14444444444@qq.com, 462ae56b5f766c9063d9485bab8af2e1, 赵六, 14444444444, 女, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [6, 20160216006, 15555555555@qq.com, 31a56597d1cfa721c47f06b7aba8537b, 田七, 15555555555, 女, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [62714ebe-84b2-4280-987a-51dd805b4206, 12335564, null, 6203b523658908e9f2e8eae8227b1436, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [7, 20160216007, 16666666666@qq.com, 56c107fa559c745087bc7761825117cb, 王八, 16666666666, 女, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [8, 20160216008, 17777777777@qq.com, 43fcbe0f248a5d053bd3d2e25ceed982, 张四, 17777777777, 女, 计科（高博）2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [8c748c34-68ba-4ab6-bb4a-052111a4dd96, 2140707168, null, d5d470762c8fc9f3024d35574693ab5f, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [9, 20160216009, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, 陈六, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [9164b69d-b49e-468a-8f0c-bddfdfe896bf, 123456789123, null, 825ea423e9c0ad5cca03a6030b872e8e, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [9f14560c-4d1a-493f-8bd6-4d732d139db3, 2140707167, null, 2ffb196ba326771b64e836a249c18639, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [a098f98d-8eec-4885-9669-417bc0fbeff2, 2148, null, 8229bd86aab0b24e35c84da82e5c8ca4, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} Result: [d90b5e01-c706-442a-b1f5-8b2dff08a2ec, 2140129259, null, ccc4a79790646ca4e93898d6d05e8207, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20009, rs-50042} closed
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20009} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20012} Parameters : [0]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20012} Types : [INTEGER]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20012} executed. 1.2697 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} open
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50044} closed
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20012} clearParameters. 
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20027} created. SELECT c.competition_id competition_id, c.competition_time competition_time, c.competition_name
        competition_name,
        c.competition_content competition_content, c.competition_site competition_site, c.competition_state
        competition_state,
        c.competition_people_sum competition_people_sum, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_competition c
        LEFT JOIN t_file f
        ON c.competition_id = f.competition_id
        WHERE c.competition_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20027} Parameters : [f46a9634-77b6-43b0-8728-545bc84f0a95]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20027} Types : [VARCHAR]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20027} executed. 3.3876 millis. SELECT c.competition_id competition_id, c.competition_time competition_time, c.competition_name
        competition_name,
        c.competition_content competition_content, c.competition_site competition_site, c.competition_state
        competition_state,
        c.competition_people_sum competition_people_sum, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_competition c
        LEFT JOIN t_file f
        ON c.competition_id = f.competition_id
        WHERE c.competition_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20027, rs-50045} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20027, rs-50045} Header: [competition_id, competition_time, competition_name, competition_content, competition_site, competition_state, competition_people_sum, file_id, file_name, file_path]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20027, rs-50045} Result: [f46a9634-77b6-43b0-8728-545bc84f0a95, 2023 年 12 月 25 日, test, test, 1, 1, 1, null, null, null]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20027, rs-50045} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20027} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20028} created. SELECT * FROM t_user_competition WHERE user_id = ? AND competition_id =
        ?
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20028} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694, f46a9634-77b6-43b0-8728-545bc84f0a95]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20028} Types : [VARCHAR, VARCHAR]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20028} executed. 1.2758 millis. SELECT * FROM t_user_competition WHERE user_id = ? AND competition_id =
        ?
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50046} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50046} Header: [competition_id, user_id, date, win_ranking, win_level_name]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50046} Result: [f46a9634-77b6-43b0-8728-545bc84f0a95, 5c027fa7-f93b-4e17-9584-2a3c5a83b694, 1718641167555, null, null]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50046} closed
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20028} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20012} Parameters : [0]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20012} Types : [INTEGER]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20012} executed. 4.2468 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} open
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10005, pstmt-20012, rs-50047} closed
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10005, pstmt-20012} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20006} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
